/****** Object:  Stored Procedure dbo.asi_UserMainUniqueUserId    Script Date: 7/3/2003 4:58:05 PM ******/
CREATE PROC asi_UserMainUniqueUserId
    @userKey uniqueidentifier,
    @userId nvarchar(50)
    AS
BEGIN
    DECLARE @isUnique bit

    SET @isUnique = 1

    SET ROWCOUNT 1

    SELECT    @isUnique = 0
     FROM    UserMain
     WHERE    UserId = @userId
       AND    UserKey <> @userKey

    SET ROWCOUNT 0

    SELECT @isUnique AS UserIdIsUnique
END

GO